Week 2 โ Dashboards & Visualisation
Week 2 โ Dashboards & Visualisation
Sessions 3โ4 ยท Mondays & Thursdays
Welcome back! This page contains the full Week 2 breakdown, exercises, and downloadable resources. Bookmark this page โ youโll need it again before each Week 2 session.
Learning Outcomes
By the end of Week 2, you will be able to:
- Design and build interactive M&E dashboards using Power BI / Google Looker Studio
- Use AI to write DAX formulas, calculated fields, and custom metrics
- Create programme performance trackers and indicator monitoring dashboards
- Build geographic / heat-map visualisations for field programme data
- Apply data storytelling principles to guide stakeholder decisions
- Set up automated dashboard refresh from live data sources
Session 3 โ Building AI-Assisted Dashboards
Monday ยท 7:00 PM EAT
- Power BI & Looker Studio with AI co-pilot
- AI-generated DAX / calculated fields
- Indicator tracking dashboard โ built live in-session
- Automated data refresh setup
๐ Session 3 materials: Slide deck (PDF) ยท Dataset for live exercise (CSV) ยท Dashboard starter template (.pbix)
Session 4 โ Data Visualisation & Storytelling
Thursday ยท 7:00 PM EAT
- Chart selection framework for M&E data
- Geographic visualisation for field programmes
- Data storytelling structure for non-technical stakeholders
- Stakeholder-specific dashboard layouts
๐ Session 4 materials: Slide deck (PDF) ยท Geographic data sample (CSV) ยท Looker Studio template link
Practical Exercises
Exercise 2.1: Build a programme performance dashboard from the provided dataset โ include KPI cards, trend lines, and a geographic component โ in under 45 minutes.
Exercise 2.2: Transform a 3-page data table into a one-page visual story using AI-guided chart selection and narrative framing for a donor audience.
Need help before the session?
Post your question in the WhatsApp group, or email vmandela99@gmail.com.
โก๏ธ Continue to Week 3 (separate password required)